package net.trustie.dao;

import net.trustie.model.lupaworld_Model;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;

public interface Lupaworld_Dao {
	
	/*标准表中的字段*//*+ "insert into t_knowledge (`deal_title`,`author`,`content`,`tags`,`reply_num`,
	 * `view_num`,`vote_num`,`collection_num`,`abstract`,`type`,`crawled_time`,`url`,`created_time`,
	 * `category`,`source`,`history`,`author_url`,`last_time`,`url_md5`")*/
	
	/*标准表剩余的字段*//*+ "insert into t_knowledge (``,``,``,``,``,
	 * ``,``,`collection_num`,`abstract`,``,``,``,
	 * `category`,`source`,``,``,`last_time`,`url_md5`")*/
	
	@Insert("insert into lupaworld (`post_id`,`url`,`deal_title`,`tags`,`content`,`type`,`view_num`,"
			+ "`reply_num`,`vote_num`,`vote_down`,`crawled_time`,`extractTime`,`author`,`author_url`,`history`,`created_time`) "
			
			
				+ "values (#{model.post_id},#{model.post_url},#{model.post_title},#{model.post_tags},#{model.post_content},"
				+ "#{model.post_type},#{model.view_num},"
				+ "#{model.reply_num},#{model.vote_up},#{model.vote_down},#{model.crawled_time},#{model.extractTime},"
				+ "#{model.author_name},#{model.author_url},#{model.history},#{model.created_time})") 
			 
			/*1标准表中独有,设置为允许为空,INSERT需要补齐*/
			/*2与标准表对应字段*/
			/*3原社区中独有保留字段*/ 
	
			/*@Insert("insert into lupaworld (3post_id,2url,2deal_title,2tags,2content,2type,2view_num,"
					+ "2reply_num,2vote_num,3vote_down,2crawled_time,3extractTime,2author,2author_url,2history,2created_time,"
					+ "collection_num,abstract,category,source,last_time,url_md5) "*/
					
			 
		
	public void add(@Param("model") lupaworld_Model model);

}
